﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPageMcSigAdmin.master" AutoEventWireup="true" CodeFile="TipoPersonal.aspx.cs" Inherits="TipoPersonal" %>

<%@ Register assembly="DevExpress.Web.v12.2, Version=12.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v12.2, Version=12.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <dx:ASPxGridView ID="ASPxGridViewTipoPersonal" runat="server" 
    AutoGenerateColumns="False" DataSourceID="SqlDataSourceTipoPersonal" 
    KeyFieldName="ATP_ID" Theme="PlasticBlue">
    <Columns>
        <dx:GridViewCommandColumn VisibleIndex="0" Caption="Opciones">
            <EditButton Visible="True">
            </EditButton>
            <NewButton Visible="True">
            </NewButton>
            <DeleteButton Visible="True">
            </DeleteButton>
            <ClearFilterButton Visible="True">
            </ClearFilterButton>
        </dx:GridViewCommandColumn>
        <dx:GridViewDataTextColumn FieldName="ATP_ID" ReadOnly="True" VisibleIndex="1" 
            Caption="Id">
            <EditFormSettings Visible="False" />
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn FieldName="ATP_NOMBRE" VisibleIndex="2" 
            Caption="Nombre">
        </dx:GridViewDataTextColumn>
    </Columns>
        <SettingsBehavior ConfirmDelete="True" />
    <Settings ShowFilterRow="True" />
</dx:ASPxGridView>
<asp:SqlDataSource ID="SqlDataSourceTipoPersonal" runat="server" 
    ConnectionString="<%$ ConnectionStrings:MCSIGConnectionString %>" 
    DeleteCommand="DELETE FROM [AUT_TIPO_PERSONAL] WHERE [ATP_ID] = @ATP_ID" 
    InsertCommand="INSERT INTO [AUT_TIPO_PERSONAL] ([ATP_NOMBRE]) VALUES (@ATP_NOMBRE)" 
    SelectCommand="SELECT * FROM [AUT_TIPO_PERSONAL]" 
    UpdateCommand="UPDATE [AUT_TIPO_PERSONAL] SET [ATP_NOMBRE] = @ATP_NOMBRE WHERE [ATP_ID] = @ATP_ID">
    <DeleteParameters>
        <asp:Parameter Name="ATP_ID" Type="Decimal" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="ATP_NOMBRE" Type="String" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="ATP_NOMBRE" Type="String" />
        <asp:Parameter Name="ATP_ID" Type="Decimal" />
    </UpdateParameters>
</asp:SqlDataSource>
</asp:Content>

